!pip install geopandas
!pip install contextily
!pip install seaborn as sns
!pip install folium
!pip install sodapy
!pip install ipywidgets
!pip install dabl

import zipfile
import geopandas as gpd
import contextily as ctx
from shapely.geometry import Point
import pandas as pd
import folium
import numpy as np
import matplotlib.pyplot as plt
import datetime
import matplotlib.dates as mdates
import seaborn as sns
import plotly.express as px
import pandas as pd
from sodapy import Socrata
import string
import ipywidgets as widgets
from dabl.plot import mosaic_plot

Requirement already satisfied: geopandas in /opt/conda/lib/python3.8/site-packages (0.12.1)
Requirement already satisfied: fiona>=1.8 in /opt/conda/lib/python3.8/site-packages (from geopandas) (1.8.18)
Requirement already satisfied: packaging in /opt/conda/lib/python3.8/site-packages (from geopandas) (22.0)
Requirement already satisfied: pyproj>=2.6.1.post1 in /opt/conda/lib/python3.8/site-packages (from geopandas) (2.6.1.post1)
Requirement already satisfied: pandas>=1.0.0 in /opt/conda/lib/python3.8/site-packages (from geopandas) (1.1.2)
Requirement already satisfied: shapely>=1.7 in /opt/conda/lib/python3.8/site-packages (from geopandas) (1.7.1)
Requirement already satisfied: attrs>=17 in /opt/conda/lib/python3.8/site-packages (from fiona>=1.8->geopandas) (20.2.0)
Requirement already satisfied: certifi in /opt/conda/lib/python3.8/site-packages (from fiona>=1.8->geopandas) (2022.9.24)
Requirement already satisfied: click<8,>=4.0 in /opt/conda/lib/python3.8/site-packages (from fiona>=1.8->geopandas) (7.1.2)
Requirement already satisfied: cligj>=0.5 in /opt/conda/lib/python3.8/site-packages (from fiona>=1.8->geopandas) (0.7.2)
Requirement already satisfied: click-plugins>=1.0 in /opt/conda/lib/python3.8/site-packages (from fiona>=1.8->geopandas) (1.1.1)
Requirement already satisfied: six>=1.7 in /opt/conda/lib/python3.8/site-packages (from fiona>=1.8->geopandas) (1.15.0)
Requirement already satisfied: munch in /opt/conda/lib/python3.8/site-packages (from fiona>=1.8->geopandas) (2.5.0)
Requirement already satisfied: numpy>=1.15.4 in /opt/conda/lib/python3.8/site-packages (from pandas>=1.0.0->geopandas) (1.19.1)
Requirement already satisfied: pytz>=2017.2 in /opt/conda/lib/python3.8/site-packages (from pandas>=1.0.0->geopandas) (2020.1)
Requirement already satisfied: python-dateutil>=2.7.3 in /opt/conda/lib/python3.8/site-packages (from pandas>=1.0.0->geopandas) (2.8.1)
Requirement already satisfied: contextily in /opt/conda/lib/python3.8/site-packages (1.2.0)
Requirement already satisfied: pillow in /opt/conda/lib/python3.8/site-packages (from contextily) (7.2.0)
Requirement already satisfied: mercantile in /opt/conda/lib/python3.8/site-packages (from contextily) (1.2.1)
Requirement already satisfied: joblib in /opt/conda/lib/python3.8/site-packages (from contextily) (0.17.0)
Requirement already satisfied: xyzservices in /opt/conda/lib/python3.8/site-packages (from contextily) (2022.9.0)
Requirement already satisfied: geopy in /opt/conda/lib/python3.8/site-packages (from contextily) (2.3.0)
Requirement already satisfied: matplotlib in /opt/conda/lib/python3.8/site-packages (from contextily) (3.3.2)
Requirement already satisfied: requests in /opt/conda/lib/python3.8/site-packages (from contextily) (2.28.1)
Requirement already satisfied: rasterio in /opt/conda/lib/python3.8/site-packages (from contextily) (1.2.1)
Requirement already satisfied: click>=3.0 in /opt/conda/lib/python3.8/site-packages (from mercantile->contextily) (7.1.2)
Requirement already satisfied: geographiclib<3,>=1.52 in /opt/conda/lib/python3.8/site-packages (from geopy->contextily) (1.52)
Requirement already satisfied: numpy>=1.15 in /opt/conda/lib/python3.8/site-packages (from matplotlib->contextily) (1.19.1)
Requirement already satisfied: certifi>=2020.06.20 in /opt/conda/lib/python3.8/site-packages (from matplotlib->contextily) (2022.9.24)
Requirement already satisfied: pyparsing!=2.0.4,!=2.1.2,!=2.1.6,>=2.0.3 in /opt/conda/lib/python3.8/site-packages (from matplotlib->contextily) (2.4.7)
Requirement already satisfied: cycler>=0.10 in /opt/conda/lib/python3.8/site-packages (from matplotlib->contextily) (0.10.0)
Requirement already satisfied: python-dateutil>=2.1 in /opt/conda/lib/python3.8/site-packages (from matplotlib->contextily) (2.8.1)
Requirement already satisfied: kiwisolver>=1.0.1 in /opt/conda/lib/python3.8/site-packages (from matplotlib->contextily) (1.2.0)
Requirement already satisfied: charset-normalizer<3,>=2 in /opt/conda/lib/python3.8/site-packages (from requests->contextily) (2.1.1)
Requirement already satisfied: idna<4,>=2.5 in /opt/conda/lib/python3.8/site-packages (from requests->contextily) (2.10)
Requirement already satisfied: urllib3<1.27,>=1.21.1 in /opt/conda/lib/python3.8/site-packages (from requests->contextily) (1.25.10)
Requirement already satisfied: cligj>=0.5 in /opt/conda/lib/python3.8/site-packages (from rasterio->contextily) (0.7.2)
Requirement already satisfied: affine in /opt/conda/lib/python3.8/site-packages (from rasterio->contextily) (2.3.1)
Requirement already satisfied: click-plugins in /opt/conda/lib/python3.8/site-packages (from rasterio->contextily) (1.1.1)
Requirement already satisfied: attrs in /opt/conda/lib/python3.8/site-packages (from rasterio->contextily) (20.2.0)
Requirement already satisfied: snuggs>=1.4.1 in /opt/conda/lib/python3.8/site-packages (from rasterio->contextily) (1.4.7)
Requirement already satisfied: six in /opt/conda/lib/python3.8/site-packages (from cycler>=0.10->matplotlib->contextily) (1.15.0)
Requirement already satisfied: seaborn in /opt/conda/lib/python3.8/site-packages (0.11.0)
ERROR: Could not find a version that satisfies the requirement as (from versions: none)
ERROR: No matching distribution found for as
Requirement already satisfied: folium in /opt/conda/lib/python3.8/site-packages (0.13.0)
Requirement already satisfied: requests in /opt/conda/lib/python3.8/site-packages (from folium) (2.28.1)
Requirement already satisfied: branca>=0.3.0 in /opt/conda/lib/python3.8/site-packages (from folium) (0.6.0)
Requirement already satisfied: jinja2>=2.9 in /opt/conda/lib/python3.8/site-packages (from folium) (2.11.2)
Requirement already satisfied: numpy in /opt/conda/lib/python3.8/site-packages (from folium) (1.19.1)
Requirement already satisfied: charset-normalizer<3,>=2 in /opt/conda/lib/python3.8/site-packages (from requests->folium) (2.1.1)
Requirement already satisfied: idna<4,>=2.5 in /opt/conda/lib/python3.8/site-packages (from requests->folium) (2.10)
Requirement already satisfied: urllib3<1.27,>=1.21.1 in /opt/conda/lib/python3.8/site-packages (from requests->folium) (1.25.10)
Requirement already satisfied: certifi>=2017.4.17 in /opt/conda/lib/python3.8/site-packages (from requests->folium) (2022.9.24)
Requirement already satisfied: MarkupSafe>=0.23 in /opt/conda/lib/python3.8/site-packages (from jinja2>=2.9->folium) (1.1.1)
Requirement already satisfied: sodapy in /opt/conda/lib/python3.8/site-packages (2.2.0)
Requirement already satisfied: requests>=2.28.1 in /opt/conda/lib/python3.8/site-packages (from sodapy) (2.28.1)
Requirement already satisfied: certifi>=2017.4.17 in /opt/conda/lib/python3.8/site-packages (from requests>=2.28.1->sodapy) (2022.9.24)
Requirement already satisfied: idna<4,>=2.5 in /opt/conda/lib/python3.8/site-packages (from requests>=2.28.1->sodapy) (2.10)
Requirement already satisfied: charset-normalizer<3,>=2 in /opt/conda/lib/python3.8/site-packages (from requests>=2.28.1->sodapy) (2.1.1)
Requirement already satisfied: urllib3<1.27,>=1.21.1 in /opt/conda/lib/python3.8/site-packages (from requests>=2.28.1->sodapy) (1.25.10)
Requirement already satisfied: ipywidgets in /opt/conda/lib/python3.8/site-packages (7.5.1)
Requirement already satisfied: ipython>=4.0.0; python_version >= "3.3" in /opt/conda/lib/python3.8/site-packages (from ipywidgets) (7.18.1)
Requirement already satisfied: nbformat>=4.2.0 in /opt/conda/lib/python3.8/site-packages (from ipywidgets) (5.0.7)
Requirement already satisfied: widgetsnbextension~=3.5.0 in /opt/conda/lib/python3.8/site-packages (from ipywidgets) (3.5.1)
Requirement already satisfied: ipykernel>=4.5.1 in /opt/conda/lib/python3.8/site-packages (from ipywidgets) (5.3.4)
Requirement already satisfied: traitlets>=4.3.1 in /opt/conda/lib/python3.8/site-packages (from ipywidgets) (5.0.4)
Requirement already satisfied: pexpect>4.3; sys_platform != "win32" in /opt/conda/lib/python3.8/site-packages (from ipython>=4.0.0; python_version >= "3.3"->ipywidgets) (4.8.0)
Requirement already satisfied: prompt-toolkit!=3.0.0,!=3.0.1,<3.1.0,>=2.0.0 in /opt/conda/lib/python3.8/site-packages (from ipython>=4.0.0; python_version >= "3.3"->ipywidgets) (3.0.7)
Requirement already satisfied: jedi>=0.10 in /opt/conda/lib/python3.8/site-packages (from ipython>=4.0.0; python_version >= "3.3"->ipywidgets) (0.17.2)
Requirement already satisfied: pickleshare in /opt/conda/lib/python3.8/site-packages (from ipython>=4.0.0; python_version >= "3.3"->ipywidgets) (0.7.5)
Requirement already satisfied: decorator in /opt/conda/lib/python3.8/site-packages (from ipython>=4.0.0; python_version >= "3.3"->ipywidgets) (4.4.2)
Requirement already satisfied: pygments in /opt/conda/lib/python3.8/site-packages (from ipython>=4.0.0; python_version >= "3.3"->ipywidgets) (2.7.1)
Requirement already satisfied: setuptools>=18.5 in /opt/conda/lib/python3.8/site-packages (from ipython>=4.0.0; python_version >= "3.3"->ipywidgets) (49.6.0.post20200917)
Requirement already satisfied: backcall in /opt/conda/lib/python3.8/site-packages (from ipython>=4.0.0; python_version >= "3.3"->ipywidgets) (0.2.0)
Requirement already satisfied: jsonschema!=2.5.0,>=2.4 in /opt/conda/lib/python3.8/site-packages (from nbformat>=4.2.0->ipywidgets) (3.2.0)
Requirement already satisfied: jupyter-core in /opt/conda/lib/python3.8/site-packages (from nbformat>=4.2.0->ipywidgets) (4.6.3)
Requirement already satisfied: ipython-genutils in /opt/conda/lib/python3.8/site-packages (from nbformat>=4.2.0->ipywidgets) (0.2.0)
Requirement already satisfied: notebook>=4.4.1 in /opt/conda/lib/python3.8/site-packages (from widgetsnbextension~=3.5.0->ipywidgets) (6.1.4)
Requirement already satisfied: tornado>=4.2 in /opt/conda/lib/python3.8/site-packages (from ipykernel>=4.5.1->ipywidgets) (6.0.4)
Requirement already satisfied: jupyter-client in /opt/conda/lib/python3.8/site-packages (from ipykernel>=4.5.1->ipywidgets) (6.1.7)
Requirement already satisfied: ptyprocess>=0.5 in /opt/conda/lib/python3.8/site-packages (from pexpect>4.3; sys_platform != "win32"->ipython>=4.0.0; python_version >= "3.3"->ipywidgets) (0.6.0)
Requirement already satisfied: wcwidth in /opt/conda/lib/python3.8/site-packages (from prompt-toolkit!=3.0.0,!=3.0.1,<3.1.0,>=2.0.0->ipython>=4.0.0; python_version >= "3.3"->ipywidgets) (0.2.5)
Requirement already satisfied: parso<0.8.0,>=0.7.0 in /opt/conda/lib/python3.8/site-packages (from jedi>=0.10->ipython>=4.0.0; python_version >= "3.3"->ipywidgets) (0.7.1)
Requirement already satisfied: six>=1.11.0 in /opt/conda/lib/python3.8/site-packages (from jsonschema!=2.5.0,>=2.4->nbformat>=4.2.0->ipywidgets) (1.15.0)
Requirement already satisfied: attrs>=17.4.0 in /opt/conda/lib/python3.8/site-packages (from jsonschema!=2.5.0,>=2.4->nbformat>=4.2.0->ipywidgets) (20.2.0)
Requirement already satisfied: pyrsistent>=0.14.0 in /opt/conda/lib/python3.8/site-packages (from jsonschema!=2.5.0,>=2.4->nbformat>=4.2.0->ipywidgets) (0.17.3)
Requirement already satisfied: terminado>=0.8.3 in /opt/conda/lib/python3.8/site-packages (from notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (0.9.1)
Requirement already satisfied: argon2-cffi in /opt/conda/lib/python3.8/site-packages (from notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (20.1.0)
Requirement already satisfied: Send2Trash in /opt/conda/lib/python3.8/site-packages (from notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (1.5.0)
Requirement already satisfied: prometheus-client in /opt/conda/lib/python3.8/site-packages (from notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (0.8.0)
Requirement already satisfied: jinja2 in /opt/conda/lib/python3.8/site-packages (from notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (2.11.2)
Requirement already satisfied: nbconvert in /opt/conda/lib/python3.8/site-packages (from notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (6.0.7)
Requirement already satisfied: pyzmq>=17 in /opt/conda/lib/python3.8/site-packages (from notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (19.0.2)
Requirement already satisfied: python-dateutil>=2.1 in /opt/conda/lib/python3.8/site-packages (from jupyter-client->ipykernel>=4.5.1->ipywidgets) (2.8.1)
Requirement already satisfied: cffi>=1.0.0 in /opt/conda/lib/python3.8/site-packages (from argon2-cffi->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (1.14.3)
Requirement already satisfied: MarkupSafe>=0.23 in /opt/conda/lib/python3.8/site-packages (from jinja2->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (1.1.1)
Requirement already satisfied: defusedxml in /opt/conda/lib/python3.8/site-packages (from nbconvert->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (0.6.0)
Requirement already satisfied: bleach in /opt/conda/lib/python3.8/site-packages (from nbconvert->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (3.2.1)
Requirement already satisfied: entrypoints>=0.2.2 in /opt/conda/lib/python3.8/site-packages (from nbconvert->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (0.3)
Requirement already satisfied: testpath in /opt/conda/lib/python3.8/site-packages (from nbconvert->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (0.4.4)
Requirement already satisfied: mistune<2,>=0.8.1 in /opt/conda/lib/python3.8/site-packages (from nbconvert->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (0.8.4)
Requirement already satisfied: nbclient<0.6.0,>=0.5.0 in /opt/conda/lib/python3.8/site-packages (from nbconvert->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (0.5.0)
Requirement already satisfied: pandocfilters>=1.4.1 in /opt/conda/lib/python3.8/site-packages (from nbconvert->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (1.4.2)
Requirement already satisfied: jupyterlab-pygments in /opt/conda/lib/python3.8/site-packages (from nbconvert->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (0.1.2)
Requirement already satisfied: pycparser in /opt/conda/lib/python3.8/site-packages (from cffi>=1.0.0->argon2-cffi->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (2.20)
Requirement already satisfied: webencodings in /opt/conda/lib/python3.8/site-packages (from bleach->nbconvert->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (0.5.1)
Requirement already satisfied: packaging in /opt/conda/lib/python3.8/site-packages (from bleach->nbconvert->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (22.0)
Requirement already satisfied: nest-asyncio in /opt/conda/lib/python3.8/site-packages (from nbclient<0.6.0,>=0.5.0->nbconvert->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (1.4.1)
Requirement already satisfied: async-generator in /opt/conda/lib/python3.8/site-packages (from nbclient<0.6.0,>=0.5.0->nbconvert->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets) (1.10)
Collecting dabl
  Downloading dabl-0.2.4-py3-none-any.whl (563 kB)
     |████████████████████████████████| 563 kB 7.4 MB/s eta 0:00:01
Requirement already satisfied: pandas in /opt/conda/lib/python3.8/site-packages (from dabl) (1.1.2)
Collecting matplotlib>=3.4
  Downloading matplotlib-3.6.2-cp38-cp38-manylinux_2_12_x86_64.manylinux2010_x86_64.whl (9.4 MB)
     |████████████████████████████████| 9.4 MB 29.2 MB/s eta 0:00:01
Requirement already satisfied: scipy in /opt/conda/lib/python3.8/site-packages (from dabl) (1.5.2)
Requirement already satisfied: numpy in /opt/conda/lib/python3.8/site-packages (from dabl) (1.19.1)
Collecting scikit-learn>=1.0
  Downloading scikit_learn-1.2.0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (9.7 MB)
     |████████████████████████████████| 9.7 MB 42.9 MB/s eta 0:00:01
Requirement already satisfied: seaborn in /opt/conda/lib/python3.8/site-packages (from dabl) (0.11.0)
Requirement already satisfied: python-dateutil>=2.7.3 in /opt/conda/lib/python3.8/site-packages (from pandas->dabl) (2.8.1)
Requirement already satisfied: pytz>=2017.2 in /opt/conda/lib/python3.8/site-packages (from pandas->dabl) (2020.1)
Requirement already satisfied: pillow>=6.2.0 in /opt/conda/lib/python3.8/site-packages (from matplotlib>=3.4->dabl) (7.2.0)
Requirement already satisfied: packaging>=20.0 in /opt/conda/lib/python3.8/site-packages (from matplotlib>=3.4->dabl) (22.0)
Requirement already satisfied: kiwisolver>=1.0.1 in /opt/conda/lib/python3.8/site-packages (from matplotlib>=3.4->dabl) (1.2.0)
Collecting fonttools>=4.22.0
  Downloading fonttools-4.38.0-py3-none-any.whl (965 kB)
     |████████████████████████████████| 965 kB 21.1 MB/s eta 0:00:01
Requirement already satisfied: cycler>=0.10 in /opt/conda/lib/python3.8/site-packages (from matplotlib>=3.4->dabl) (0.10.0)
Collecting contourpy>=1.0.1
  Downloading contourpy-1.0.6-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (295 kB)
     |████████████████████████████████| 295 kB 46.7 MB/s eta 0:00:01
Requirement already satisfied: pyparsing>=2.2.1 in /opt/conda/lib/python3.8/site-packages (from matplotlib>=3.4->dabl) (2.4.7)
Requirement already satisfied: threadpoolctl>=2.0.0 in /opt/conda/lib/python3.8/site-packages (from scikit-learn>=1.0->dabl) (2.1.0)
Collecting joblib>=1.1.1
  Downloading joblib-1.2.0-py3-none-any.whl (297 kB)
     |████████████████████████████████| 297 kB 1.6 MB/s eta 0:00:01
Requirement already satisfied: six>=1.5 in /opt/conda/lib/python3.8/site-packages (from python-dateutil>=2.7.3->pandas->dabl) (1.15.0)
Installing collected packages: fonttools, contourpy, matplotlib, joblib, scikit-learn, dabl
  Attempting uninstall: matplotlib
    Found existing installation: matplotlib 3.3.2
    Uninstalling matplotlib-3.3.2:
      Successfully uninstalled matplotlib-3.3.2
  Attempting uninstall: joblib
    Found existing installation: joblib 0.17.0
    Uninstalling joblib-0.17.0:
      Successfully uninstalled joblib-0.17.0
  Attempting uninstall: scikit-learn
    Found existing installation: scikit-learn 0.23.2
    Uninstalling scikit-learn-0.23.2:
      Successfully uninstalled scikit-learn-0.23.2
Successfully installed contourpy-1.0.6 dabl-0.2.4 fonttools-4.38.0 joblib-1.2.0 matplotlib-3.6.2 scikit-learn-1.2.0

# Unauthenticated client only works with public data sets. Note 'None'
# in place of application token, and no username or password:
client = Socrata("data.sfgov.org", None)

results = client.get("wg3w-h783", limit=1000000)

# Convert to pandas DataFrame
df1 = pd.DataFrame.from_records(results)
df = df1

WARNING:root:Requests made without an app_token will be subject to strict throttling limits.

df = df1

df.columns

Index(['incident_datetime', 'incident_date', 'incident_time', 'incident_year',
       'incident_day_of_week', 'report_datetime', 'row_id', 'incident_id',
       'incident_number', 'report_type_code', 'report_type_description',
       'filed_online', 'incident_code', 'incident_category',
       'incident_subcategory', 'incident_description', 'resolution',
       'police_district', 'cad_number', 'intersection', 'cnn',
       'analysis_neighborhood', 'supervisor_district', 'latitude', 'longitude',
       'point', ':@computed_region_jwn9_ihcz', ':@computed_region_26cr_cadq',
       ':@computed_region_qgnn_b9vv', ':@computed_region_nqbw_i6c3',
       ':@computed_region_h4ep_8xdi', ':@computed_region_n4xg_c4py',
       ':@computed_region_jg9y_a9du'],
      dtype='object')

df.drop(columns=[':@computed_region_jwn9_ihcz', ':@computed_region_26cr_cadq', ':@computed_region_qgnn_b9vv',
                ':@computed_region_nqbw_i6c3', ':@computed_region_h4ep_8xdi',':@computed_region_n4xg_c4py',
                ':@computed_region_jg9y_a9du', 'point'], inplace = True)

df['incident_datetime']=pd.to_datetime(df['incident_datetime'], errors = 'coerce')
df['incident_year']=pd.to_datetime(df['incident_year'], errors = 'coerce')
df['incident_date']=pd.to_datetime(df['incident_date'], errors = 'coerce')
df['report_datetime']=pd.to_datetime(df['report_datetime'], errors = 'coerce')

df.dtypes

incident_datetime          datetime64[ns]
incident_date              datetime64[ns]
incident_time                      object
incident_year              datetime64[ns]
incident_day_of_week               object
report_datetime            datetime64[ns]
row_id                             object
incident_id                        object
incident_number                    object
report_type_code                   object
report_type_description            object
filed_online                       object
incident_code                      object
incident_category                  object
incident_subcategory               object
incident_description               object
resolution                         object
police_district                    object
cad_number                         object
intersection                       object
cnn                                object
analysis_neighborhood              object
supervisor_district                object
latitude                           object
longitude                          object
dtype: object

def o_str(value):
    return str(value)

def o_date(value):
    return str(value)

def o_numeric(value):
    return float(value)

df['incident_id']=df['incident_id'].apply(o_numeric)
df['row_id']=df['row_id'].apply(o_numeric)
df['incident_code']=df['incident_code'].apply(o_numeric)
df['incident_number']=df['incident_number'].apply(o_numeric)
df['cad_number']=df['cad_number'].apply(o_numeric)
df['cnn']=df['cnn'].apply(o_numeric)

df['report_type_description']=df['report_type_description'].apply(o_str)
df['incident_category']=df['incident_category'].apply(o_str)
df['incident_subcategory']=df['incident_subcategory'].apply(o_str)
df['resolution']=df['resolution'].apply(o_str)
df['police_district']=df['police_district'].apply(o_str)
df['analysis_neighborhood']=df['analysis_neighborhood'].apply(o_str)

df['latitude']=df['latitude'].apply(o_numeric)
df['longitude']=df['longitude'].apply(o_numeric)

df.resolution.unique()

array(['Open or Active', 'Cite or Arrest Adult', 'Exceptional Adult',
       'Unfounded'], dtype=object)

df.police_district.unique()

array(['Southern', 'Out of SF', 'Central', 'Mission', 'Richmond',
       'Ingleside', 'Park', 'Northern', 'Bayview', 'Tenderloin',
       'Taraval'], dtype=object)

df.report_type_description.unique()

array(['Coplogic Initial', 'Vehicle Supplement', 'Initial Supplement',
       'Initial', 'Vehicle Initial', 'Coplogic Supplement'], dtype=object)

df.analysis_neighborhood.unique()

array(['nan', 'Excelsior', 'Russian Hill', 'Lone Mountain/USF',
       'Pacific Heights', 'Bayview Hunters Point', 'Glen Park', 'Mission',
       'Tenderloin', 'Hayes Valley', 'Western Addition', 'Outer Mission',
       'Marina', 'South of Market', 'Japantown', 'McLaren Park',
       'Presidio Heights', 'Mission Bay', 'Nob Hill', 'North Beach',
       'Financial District/South Beach', 'West of Twin Peaks',
       'Chinatown', 'Haight Ashbury', 'Castro/Upper Market',
       'Sunset/Parkside', 'Potrero Hill', 'Lakeshore', 'Outer Richmond',
       'Inner Sunset', 'Twin Peaks', 'Oceanview/Merced/Ingleside',
       'Portola', 'Presidio', 'Bernal Heights', 'Golden Gate Park',
       'Noe Valley', 'Visitacion Valley', 'Inner Richmond',
       'Treasure Island', 'Lincoln Park', 'Seacliff', 'null'],
      dtype=object)

# Filling in the NA values with In Person, as specified on the website, 
# any row which does not have Filled Online it is assumed that the complaint was filed in person

df['filed_online'].fillna('In Person',inplace = True)

df.dtypes

incident_datetime          datetime64[ns]
incident_date              datetime64[ns]
incident_time                      object
incident_year              datetime64[ns]
incident_day_of_week               object
report_datetime            datetime64[ns]
row_id                            float64
incident_id                       float64
incident_number                   float64
report_type_code                   object
report_type_description            object
filed_online                       object
incident_code                     float64
incident_category                  object
incident_subcategory               object
incident_description               object
resolution                         object
police_district                    object
cad_number                        float64
intersection                       object
cnn                               float64
analysis_neighborhood              object
supervisor_district                object
latitude                          float64
longitude                         float64
dtype: object

#Checking null values for each column
df.isnull().sum()

incident_datetime               0
incident_date                   0
incident_time                   0
incident_year                   0
incident_day_of_week            0
report_datetime                 0
row_id                          0
incident_id                     0
incident_number                 0
report_type_code                0
report_type_description         0
filed_online                    0
incident_code                   0
incident_category               0
incident_subcategory            0
incident_description            0
resolution                      0
police_district                 0
cad_number                 150519
intersection                35674
cnn                         35674
analysis_neighborhood           0
supervisor_district         35674
latitude                    35674
longitude                   35674
dtype: int64

#Since over 70% of the data is null drop this columns
# df.drop(columns = ['incident_day_of_week'], inplace=True)
df.cad_number.fillna('0', inplace = True)
df.intersection.fillna('0', inplace = True)
df.cnn.fillna('0', inplace = True)
df.supervisor_district.fillna('0', inplace = True)


df['latitude'].fillna(float(df['latitude'].mean()), inplace=True)
df['longitude'].fillna(float(df['longitude'].mean()), inplace=True)

df.analysis_neighborhood.fillna('0', inplace = True)

#Reindexing and finding shape of dataframe
df.iloc[:].reindex()
df.shape

(673198, 25)

This graph shows us the Count for Number of Crimes occuring in the SFO region based on Days

df.rename(columns={'incident_category': 'Incident Category'}, inplace = True)

# Barplot showing major crimes in San Francisco

plt.rcParams['figure.figsize'] = (20, 9)
plt.style.use('fast')
sns.countplot(df['Incident Category'], palette = 'hot')

plt.title('Major Crimes in San Francisco', fontweight = 20, fontsize = 20)
plt.xticks(rotation = 90)
plt.show()

/opt/conda/lib/python3.8/site-packages/seaborn/_decorators.py:36: FutureWarning: Pass the following variable as a keyword arg: x. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
  warnings.warn(

Distribution of crimes in San Francisco as per days of week

# Distribution of crimes in San Francisco as per days of week

df['incident_day_of_week'].value_counts().plot.pie(figsize = (10, 20), explode = (0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1), autopct='%1.1f%%')
plt.axis('off')
plt.title('Crime count on each day',fontsize = 20)
centre_circle = plt.Circle((0,0),0.6,fc='white')
fig = plt.gcf()
fig.gca().add_artist(centre_circle)
plt.xticks(rotation = 90)
plt.show()

Graph shows various types of crimes over the years in different regions of the city

df['incident_year'] = pd.to_datetime(df['incident_year'])
df['year'] = df['incident_year'].dt.strftime('%Y-%m-%d').astype(str)
df.head()

fig = px.histogram(data_frame = df, color = 'year', x='Incident Category', animation_frame='police_district',
             barmode='overlay', marginal='box', height = 900, width=900)
fig.show('notebook')

# Get a count of the crimes by neighborhood, returns a series
crime_neighbourhood = df.police_district.value_counts()
# Stick it into a data frame.
neighbour_df = pd.DataFrame(crime_neighbourhood)

# Set up the data frame with the required structure.
neighbour_df.index.name = 'Neighborhood'
neighbour_df.reset_index(inplace=True)
neighbour_df.rename(columns={'police_district': 'No of Crimes'}, inplace=True)
neighbour_df

	Neighborhood	No of Crimes
0	Central	100613
1	Northern	91518
2	Mission	84718
3	Southern	81150
4	Tenderloin	64532
5	Bayview	59492
6	Ingleside	50833
7	Taraval	47267
8	Richmond	41986
9	Park	31274
10	Out of SF	19815

Distribution of Number of Crimes that has occured over the period of last 4 years

x = df.groupby(['Incident Category', 'incident_year'])[['incident_year']].count()
x.rename(columns={"incident_year":"count"}, inplace=True)
crime_by_years = x.reset_index()
crime_by_years

	Incident Category	incident_year	count
0	Arson	2018-01-01	366
1	Arson	2019-01-01	313
2	Arson	2020-01-01	429
3	Arson	2021-01-01	433
4	Arson	2022-01-01	379
...	...	...	...
241	nan	2018-01-01	10
242	nan	2019-01-01	2
243	nan	2020-01-01	306
244	nan	2021-01-01	153
245	nan	2022-01-01	88

246 rows × 3 columns

df['Incident Category'] = df['Incident Category'].replace(['Motor Vehicle Theft?', 'Other Miscellaneous', 'Other Offenses', 'Weapons Offence'], 
                                                          ['Motor Vehicle Theft', 'Other', 'Other', 'Weapons Offense'])

df['incident_subcategory'] = df['incident_subcategory'].replace(['Motor Vehicle Theft?', 'Other Miscellaneous', 'Other Offenses', 'Weapons Offence'], 
                                                          ['Motor Vehicle Theft', 'Other', 'Other', 'Weapons Offense'])

This graph talks about the distribution of Number of Crimes that has occured over the period of last 4 years

fig = px.bar(crime_by_years, x='incident_year', y='count', color='Incident Category', 
            title="Counts of crimes according to categories grouped over the years",
            labels={'incident_year':'Year', 'count':'Count of crimes'})
fig.show('notebook')

Average delay time between the Incident happening and the Report time

df['time_difference'] = round(((df['report_datetime'] - df['incident_datetime']).dt.total_seconds() / 60 / 60 / 24),0)
df[['time_difference']]

	time_difference
0	1.0
1	0.0
2	0.0
3	0.0
4	0.0
...	...
673193	1.0
673194	0.0
673195	0.0
673196	0.0
673197	0.0

673198 rows × 1 columns

x = df.groupby(['incident_year'])['time_difference'].mean()
time_diff_by_year = x.reset_index()
time_diff_by_year

	incident_year	time_difference
0	2018-01-01	10.157525
1	2019-01-01	7.834363
2	2020-01-01	10.588955
3	2021-01-01	6.911124
4	2022-01-01	3.817991

fig = px.line(time_diff_by_year, x='incident_year', y='time_difference',
              title="Average Time difference between incident and report time in days over the years",
              labels={'incident_year':'Year', 'time_difference':'Time difference in days'})
fig.show('notebook')

Bargraph showing distribution of incidences as per the time of its occurance

df['incident_time']=df['incident_time'].astype('string')

df['incident_time']=df['incident_time'].str.split(':',expand=True)[0]
df['incident_time']=df['incident_time'].astype(int)

df['incident_time_category']='null'
df['incident_time_category'].dtypes

dtype('O')

# 00.00 - 06.00 : Early Morning, 6.01 - 12.00 : Morning, 12.01 - 18.00 : Evening, 18.01 - 24.00 : Night

def category(x):
    if 0<=x<=6:
        return 'Early Morning'
    elif 6<x<=12:
        return 'Morning'
    elif 12<x<=18:
        return 'Evening'
    elif 18<x<24:
        return 'Night'

df['incident_time_category'] = df['incident_time'].apply(category)

df_count = df.groupby(['incident_time_category']).count()
df_count

	incident_datetime	incident_date	incident_time	incident_year	incident_day_of_week	report_datetime	row_id	incident_id	incident_number	report_type_code	...	police_district	cad_number	intersection	cnn	analysis_neighborhood	supervisor_district	latitude	longitude	year	time_difference
incident_time_category
Early Morning	115357	115357	115357	115357	115357	115357	115357	115357	115357	115357	...	115357	115357	115357	115357	115357	115357	115357	115357	115357	115357
Evening	227333	227333	227333	227333	227333	227333	227333	227333	227333	227333	...	227333	227333	227333	227333	227333	227333	227333	227333	227333	227333
Morning	177706	177706	177706	177706	177706	177706	177706	177706	177706	177706	...	177706	177706	177706	177706	177706	177706	177706	177706	177706	177706
Night	152802	152802	152802	152802	152802	152802	152802	152802	152802	152802	...	152802	152802	152802	152802	152802	152802	152802	152802	152802	152802

4 rows × 27 columns

df_count = df.groupby(['incident_time_category']).count()
df_num=pd.DataFrame(df_count)
df_num.reset_index(inplace=True)

fig = plt.figure(figsize = (10, 7))
fig = px.bar(df_num.sort_values( 'incident_time',ascending = False), 
            x='incident_time_category', 
            y='incident_time',
            labels = {"incident_time_category":"Time when the incident occured", "incident_time":"Number of incidences" }, 
            title = "Distribution of incidences as per the time of its occurance",
            color='incident_time_category', 
            color_discrete_map={'Evening': 'red','Night': 'blue','Morning': 'green','Early Morning': 'orange'})

fig.show('notebook')

<Figure size 720x504 with 0 Axes>

Most of the incidents take place in the evening (between 12.01 to 18.00 hours) followed by night (between 18.01 to 24.00 hours), morning (between 06.01 to 12.00 hours) and early morning (between 00.00 to 06.00 hours).

df2 = df.groupby(['Incident Category','incident_subcategory']).count().reset_index()
df2.rename(columns = {'incident_id':'count'}, inplace = True)
df2

	Incident Category	incident_subcategory	incident_datetime	incident_date	incident_time	incident_year	incident_day_of_week	report_datetime	row_id	count	...	cad_number	intersection	cnn	analysis_neighborhood	supervisor_district	latitude	longitude	year	time_difference	incident_time_category
0	Arson	Arson	1920	1920	1920	1920	1920	1920	1920	1920	...	1920	1920	1920	1920	1920	1920	1920	1920	1920	1920
1	Assault	Aggravated Assault	15517	15517	15517	15517	15517	15517	15517	15517	...	15517	15517	15517	15517	15517	15517	15517	15517	15517	15517
2	Assault	Simple Assault	25402	25402	25402	25402	25402	25402	25402	25402	...	25402	25402	25402	25402	25402	25402	25402	25402	25402	25402
3	Burglary	Burglary - Commercial	4729	4729	4729	4729	4729	4729	4729	4729	...	4729	4729	4729	4729	4729	4729	4729	4729	4729	4729
4	Burglary	Burglary - Hot Prowl	4773	4773	4773	4773	4773	4773	4773	4773	...	4773	4773	4773	4773	4773	4773	4773	4773	4773	4773
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
92	Warrant	Other	10601	10601	10601	10601	10601	10601	10601	10601	...	10601	10601	10601	10601	10601	10601	10601	10601	10601	10601
93	Warrant	Warrant	9103	9103	9103	9103	9103	9103	9103	9103	...	9103	9103	9103	9103	9103	9103	9103	9103	9103	9103
94	Weapons Carrying Etc	Weapons Offense	3849	3849	3849	3849	3849	3849	3849	3849	...	3849	3849	3849	3849	3849	3849	3849	3849	3849	3849
95	Weapons Offense	Weapons Offense	4582	4582	4582	4582	4582	4582	4582	4582	...	4582	4582	4582	4582	4582	4582	4582	4582	4582	4582
96	nan	nan	559	559	559	559	559	559	559	559	...	559	559	559	559	559	559	559	559	559	559

97 rows × 28 columns

Understand which category has the most number of crimes in the city of SFO

fig = px.treemap(df2, path=[px.Constant("all"), 'Incident Category', 'incident_subcategory'], values='count')
fig.update_traces(root_color="lightgrey")
fig.update_layout(margin = dict(t=50, l=25, r=25, b=25))
fig.show()

# Get a count of the crimes by neighborhood, returns a series
crime_neighbourhood = df.police_district.value_counts()
# Stick it into a data frame.
neighbour_df = pd.DataFrame(crime_neighbourhood)

# Set up the data frame with the required structure.
neighbour_df.index.name = 'neighborhood'
neighbour_df.reset_index(inplace=True)
neighbour_df.rename(columns={'police_district': 'No of Crimes'}, inplace=True)
neighbour_df

	neighborhood	No of Crimes
0	Central	100613
1	Northern	91518
2	Mission	84718
3	Southern	81150
4	Tenderloin	64532
5	Bayview	59492
6	Ingleside	50833
7	Taraval	47267
8	Richmond	41986
9	Park	31274
10	Out of SF	19815

# San Francisco latitude and longitude values
lat = 37.77
long = -122.42

# Create map using folium
sf1_map = folium.Map(location=[lat, long], zoom_start=12)

# display the map of San Francisco
sf1_map

Make this Notebook Trusted to load map: File -> Trust Notebook

# Read in the geojson file with the neighborhoods and lat/long 
#sf_geo  = r'SanFrancisco.Neighborhoods.json'
sf_geo = r"https://cocl.us/sanfran_geojson"

# Create the map, centered on San Francisco with zoom level 12. 
SF_map = folium.Map(location=[37.7749, -122.4194], zoom_start=12)

# Add the choropleth to the map, with the wanted options.
SF_map.choropleth(
    geo_data=sf_geo,
    name='Choropleth',
    data = neighbour_df,
    columns=['neighborhood','No of Crimes'], 
    key_on='feature.properties.DISTRICT', 
    fill_color = 'YlOrRd',
    fill_opacity = 0.7,
    line_opacity = 0.2,
    legend_name = 'Crimes in SF'
)
SF_map

/opt/conda/lib/python3.8/site-packages/folium/folium.py:407: FutureWarning:

The choropleth  method has been deprecated. Instead use the new Choropleth class, which has the same arguments. See the example notebook 'GeoJSON_and_choropleth' for how to do this.

Make this Notebook Trusted to load map: File -> Trust Notebook

Interactive map to visualize incident Hotspots based on choice of Neighbourhood and the Incident Type

df_temp = df.loc[df['analysis_neighborhood'] != 'nan']

def plot_by_crime_neighbourhood_type(Neighbourhood, Type):

    temp = df_temp.loc[(df_temp['analysis_neighborhood'] == Neighbourhood) & (df_temp['Incident Category'] == Type)] 
    fig = px.scatter_geo(temp, 'latitude', 'longitude',
                    title='Crime Hotspots based on Analysis Neighbourhood and Types',
                    height=800, width=800, 
                    color = temp['incident_subcategory'])
    
    fig.update_geos(lonaxis_range = [-122.575, -122.325], lataxis_range = [37.69, 37.85], 
                      scope = 'north america', showocean=True, showland=True)
    
    fig.show()

widgets.interact(plot_by_crime_neighbourhood_type, 
                 Neighbourhood = list(df_temp['analysis_neighborhood'].unique()),
                 Type = list(df_temp['Incident Category'].unique()))

<function __main__.plot_by_crime_neighbourhood_type(Neighbourhood, Type)>

Interactive map to visualize incident Hotspots based on choice of Year, Day of Week and Time

df['Year'] = df['incident_year'].astype(str).str[0:4]
df['Year'] = df['Year'].astype(int)

def plot_by_year_day_time(Year, Day, Time):

    temp = df.loc[(df['incident_day_of_week'] == Day) & (df['incident_time_category'] == Time) & (df['Year'] == Year)] 
    fig = px.scatter_geo(temp, 'latitude', 'longitude',
                    title='Crime Hotspots based on Year, Day and Time',
                    height=800, width=800,
                    color=temp['Incident Category'])
    
    fig.update_geos(lonaxis_range = [-122.575, -122.325], lataxis_range = [37.69, 37.85], 
                      scope = 'north america', showocean=True, showland=True, showcountries=True)
    
    fig.show('notebook')

Year_list = list(df['Year'].unique())
Year_list.sort(reverse=True)
Day_list = list(df['incident_day_of_week'].unique())
Day_list.sort(reverse=True)
Time_list = list(df['incident_time_category'].unique())
Time_list.sort(reverse=True)

widgets.interact(plot_by_year_day_time, 
                 Year = Year_list,
                 Day = Day_list,
                 Time = Time_list)

<function __main__.plot_by_year_day_time(Year, Day, Time)>

Mosaic plot to visualize the proportion of Incident Resolution Techniques with the Type of Report Descriptions

mosaic_plot(df, 'report_type_description', 'resolution')
plt.title("Mosaic Plot showing the Resolution Techniques and Report Type Descriptions", fontsize=20)
plt.xlabel("Resolution Techniques", fontsize=15)
plt.ylabel("Report Type Description", fontsize=15)
plt.show()

References

https://stackoverflow.com/questions/70471888/text-as-tooltip-popup-or-labels-in-folium-choropleth-geojson-polygons

https://stackoverflow.com/questions/46223224/matplotlib-plot-countplot-for-two-or-more-column-on-single-plot

https://matplotlib.org/stable/tutorials/introductory/customizing.html

https://medium.com/@kvnamiparaa-better-visualisation-of-pie-charts-by-matplotlib-935b7667d77f

https://dabl.github.io/dev/auto_examples/plot/plot_mosaic.html

https://scitools.org.uk/cartopy/docs/latest/matplotlib/feature_interface.html

https://plotly.com/python/bar-charts/

\n

\n\n"}, "metadata": {}, "output_type": "display_data"}]}}, "82f6992d52284c5086d7aa5bec776639": {"model_module": "@jupyter-widgets/controls", "model_module_version": "1.5.0", "model_name": "DescriptionStyleModel", "state": {"_model_module": "@jupyter-widgets/controls", "_model_module_version": "1.5.0", "_model_name": "DescriptionStyleModel", "_view_count": null, "_view_module": "@jupyter-widgets/base", "_view_module_version": "1.2.0", "_view_name": "StyleView", "description_width": ""}}, "8419ef969a87463bbd0a77ca8cb48174": {"model_module": "@jupyter-widgets/controls", "model_module_version": "1.5.0", "model_name": "VBoxModel", "state": {"_dom_classes": ["widget-interact"], "_model_module": "@jupyter-widgets/controls", "_model_module_version": "1.5.0", "_model_name": "VBoxModel", "_view_count": null, "_view_module": "@jupyter-widgets/controls", "_view_module_version": "1.5.0", "_view_name": "VBoxView", "box_style": "", "children": ["IPY_MODEL_ed67dba793c24bf5aa7e2fac0062b30a", "IPY_MODEL_71f787180a1d4b0482df5138e8ad6dfa", "IPY_MODEL_e8082af34c884ef3b065c6263a1ed2db"], "layout": "IPY_MODEL_292a96fd89e241b48a2945d17c6ff443"}}, "8bdd8f2889e74fe9b5c4ddca56a733cd": {"model_module": "@jupyter-widgets/base", "model_module_version": "1.2.0", "model_name": "LayoutModel", "state": {"_model_module": "@jupyter-widgets/base", "_model_module_version": "1.2.0", "_model_name": "LayoutModel", "_view_count": null, "_view_module": "@jupyter-widgets/base", "_view_module_version": "1.2.0", "_view_name": "LayoutView", "align_content": null, "align_items": null, "align_self": null, "border": null, "bottom": null, "display": null, "flex": null, "flex_flow": null, "grid_area": null, "grid_auto_columns": null, "grid_auto_flow": null, "grid_auto_rows": null, "grid_column": null, "grid_gap": null, "grid_row": null, "grid_template_areas": null, "grid_template_columns": null, "grid_template_rows": null, "height": null, "justify_content": null, "justify_items": null, "left": null, "margin": null, "max_height": null, "max_width": null, "min_height": null, "min_width": null, "object_fit": null, "object_position": null, "order": null, "overflow": null, "overflow_x": null, "overflow_y": null, "padding": null, "right": null, "top": null, "visibility": null, "width": null}}, "973e78241a8a49f1a99f663d48bdf3ea": {"model_module": "@jupyter-widgets/base", "model_module_version": "1.2.0", "model_name": "LayoutModel", "state": {"_model_module": "@jupyter-widgets/base", "_model_module_version": "1.2.0", "_model_name": "LayoutModel", "_view_count": null, "_view_module": "@jupyter-widgets/base", "_view_module_version": "1.2.0", "_view_name": "LayoutView", "align_content": null, "align_items": null, "align_self": null, "border": null, "bottom": null, "display": null, "flex": null, "flex_flow": null, "grid_area": null, "grid_auto_columns": null, "grid_auto_flow": null, "grid_auto_rows": null, "grid_column": null, "grid_gap": null, "grid_row": null, "grid_template_areas": null, "grid_template_columns": null, "grid_template_rows": null, "height": null, "justify_content": null, "justify_items": null, "left": null, "margin": null, "max_height": null, "max_width": null, "min_height": null, "min_width": null, "object_fit": null, "object_position": null, "order": null, "overflow": null, "overflow_x": null, "overflow_y": null, "padding": null, "right": null, "top": null, "visibility": null, "width": null}}, "ab3c35c48b0d4a409a5abe99cbfe6fae": {"model_module": "@jupyter-widgets/base", "model_module_version": "1.2.0", "model_name": "LayoutModel", "state": {"_model_module": "@jupyter-widgets/base", "_model_module_version": "1.2.0", "_model_name": "LayoutModel", "_view_count": null, "_view_module": "@jupyter-widgets/base", "_view_module_version": "1.2.0", "_view_name": "LayoutView", "align_content": null, "align_items": null, "align_self": null, "border": null, "bottom": null, "display": null, "flex": null, "flex_flow": null, "grid_area": null, "grid_auto_columns": null, "grid_auto_flow": null, "grid_auto_rows": null, "grid_column": null, "grid_gap": null, "grid_row": null, "grid_template_areas": null, "grid_template_columns": null, "grid_template_rows": null, "height": null, "justify_content": null, "justify_items": null, "left": null, "margin": null, "max_height": null, "max_width": null, "min_height": null, "min_width": null, "object_fit": null, "object_position": null, "order": null, "overflow": null, "overflow_x": null, "overflow_y": null, "padding": null, "right": null, "top": null, "visibility": null, "width": null}}, "abc4d1fff7174442aacbd8d9b298b0f0": {"model_module": "@jupyter-widgets/base", "model_module_version": "1.2.0", "model_name": "LayoutModel", "state": {"_model_module": "@jupyter-widgets/base", "_model_module_version": "1.2.0", "_model_name": "LayoutModel", "_view_count": null, "_view_module": "@jupyter-widgets/base", "_view_module_version": "1.2.0", "_view_name": "LayoutView", "align_content": null, "align_items": null, "align_self": null, "border": null, "bottom": null, "display": null, "flex": null, "flex_flow": null, "grid_area": null, "grid_auto_columns": null, "grid_auto_flow": null, "grid_auto_rows": null, "grid_column": null, "grid_gap": null, "grid_row": null, "grid_template_areas": null, "grid_template_columns": null, "grid_template_rows": null, "height": null, "justify_content": null, "justify_items": null, "left": null, "margin": null, "max_height": null, "max_width": null, "min_height": null, "min_width": null, "object_fit": null, "object_position": null, "order": null, "overflow": null, "overflow_x": null, "overflow_y": null, "padding": null, "right": null, "top": null, "visibility": null, "width": null}}, "db7a22c523524760b7e827730950d276": {"model_module": "@jupyter-widgets/base", "model_module_version": "1.2.0", "model_name": "LayoutModel", "state": {"_model_module": "@jupyter-widgets/base", "_model_module_version": "1.2.0", "_model_name": "LayoutModel", "_view_count": null, "_view_module": "@jupyter-widgets/base", "_view_module_version": "1.2.0", "_view_name": "LayoutView", "align_content": null, "align_items": null, "align_self": null, "border": null, "bottom": null, "display": null, "flex": null, "flex_flow": null, "grid_area": null, "grid_auto_columns": null, "grid_auto_flow": null, "grid_auto_rows": null, "grid_column": null, "grid_gap": null, "grid_row": null, "grid_template_areas": null, "grid_template_columns": null, "grid_template_rows": null, "height": null, "justify_content": null, "justify_items": null, "left": null, "margin": null, "max_height": null, "max_width": null, "min_height": null, "min_width": null, "object_fit": null, "object_position": null, "order": null, "overflow": null, "overflow_x": null, "overflow_y": null, "padding": null, "right": null, "top": null, "visibility": null, "width": null}}, "df84cca310f04cfa93a3a8a17f8582b6": {"model_module": "@jupyter-widgets/controls", "model_module_version": "1.5.0", "model_name": "DescriptionStyleModel", "state": {"_model_module": "@jupyter-widgets/controls", "_model_module_version": "1.5.0", "_model_name": "DescriptionStyleModel", "_view_count": null, "_view_module": "@jupyter-widgets/base", "_view_module_version": "1.2.0", "_view_name": "StyleView", "description_width": ""}}, "e8082af34c884ef3b065c6263a1ed2db": {"model_module": "@jupyter-widgets/output", "model_module_version": "1.0.0", "model_name": "OutputModel", "state": {"_dom_classes": [], "_model_module": "@jupyter-widgets/output", "_model_module_version": "1.0.0", "_model_name": "OutputModel", "_view_count": null, "_view_module": "@jupyter-widgets/output", "_view_module_version": "1.0.0", "_view_name": "OutputView", "layout": "IPY_MODEL_ab3c35c48b0d4a409a5abe99cbfe6fae", "msg_id": "", "outputs": [{"data": {"text/html": "\n\n\n

\n

\n\n"}, "metadata": {}, "output_type": "display_data"}]}}, "e8ed92a78e774604877a3f44bf2d8791": {"model_module": "@jupyter-widgets/controls", "model_module_version": "1.5.0", "model_name": "DropdownModel", "state": {"_dom_classes": [], "_model_module": "@jupyter-widgets/controls", "_model_module_version": "1.5.0", "_model_name": "DropdownModel", "_options_labels": ["2022", "2021", "2020", "2019", "2018"], "_view_count": null, "_view_module": "@jupyter-widgets/controls", "_view_module_version": "1.5.0", "_view_name": "DropdownView", "description": "Year", "description_tooltip": null, "disabled": false, "index": 0, "layout": "IPY_MODEL_1871ed115e83436e87bfa1d35bfccf35", "style": "IPY_MODEL_36733310a6954246b2a2f10a94e9975f"}}, "ed67dba793c24bf5aa7e2fac0062b30a": {"model_module": "@jupyter-widgets/controls", "model_module_version": "1.5.0", "model_name": "DropdownModel", "state": {"_dom_classes": [], "_model_module": "@jupyter-widgets/controls", "_model_module_version": "1.5.0", "_model_name": "DropdownModel", "_options_labels": ["Excelsior", "Russian Hill", "Lone Mountain/USF", "Pacific Heights", "Bayview Hunters Point", "Glen Park", "Mission", "Tenderloin", "Hayes Valley", "Western Addition", "Outer Mission", "Marina", "South of Market", "Japantown", "McLaren Park", "Presidio Heights", "Mission Bay", "Nob Hill", "North Beach", "Financial District/South Beach", "West of Twin Peaks", "Chinatown", "Haight Ashbury", "Castro/Upper Market", "Sunset/Parkside", "Potrero Hill", "Lakeshore", "Outer Richmond", "Inner Sunset", "Twin Peaks", "Oceanview/Merced/Ingleside", "Portola", "Presidio", "Bernal Heights", "Golden Gate Park", "Noe Valley", "Visitacion Valley", "Inner Richmond", "Treasure Island", "Lincoln Park", "Seacliff", "null"], "_view_count": null, "_view_module": "@jupyter-widgets/controls", "_view_module_version": "1.5.0", "_view_name": "DropdownView", "description": "Neighbourhood", "description_tooltip": null, "disabled": false, "index": 0, "layout": "IPY_MODEL_973e78241a8a49f1a99f663d48bdf3ea", "style": "IPY_MODEL_df84cca310f04cfa93a3a8a17f8582b6"}}}